0 (OBJECTIDIPARENTIDIOBJECTTYPEC OBJECTNAMECPROPERTYMCODEMRIINFOCUSERM Database Database  Database TransactionLog Database StoredProceduresSource C Database StoredProceduresObject D Table setup 3 Field key_name 5 Field value 6 Index key_name 4 Table customer  Index company_na 8 Index customer_i 9 Table user_level Index group_id M Table supplier  Index contact_na U Index company_na V Index supplier_i W Table shippers  Index company_na f Index shipper_id g Table products  Index category_i m Index supplier_i n Index product_na o Index product_id p Table order_line_items  Index product_id  Index order_id Table orders Index shipper_id Index customer_i Index employee_i !Index order_numb "Table employee  #"Index group_id $"Index last_name %"Index employee_i &Table category ! '&Index category_i (View sales summary )(Field exp_1 *(Field sum_unit_price +View shipper listing ,+Field company_name -View product listing  .-Field product_name  /-Field quantity_in_unit  0-Field unit_price  1-Field unit_cost  2Relation Relation 1 CRR 3"Relation Relation 1 CRR 4Relation Relation 1 ~CRR 5Relation Relation 1 }CRR 6Relation Relation 2 |CCR 7Relation Relation 2 kCRR 8Relation Relation 2 dCRR 9Relation Relation 3 SCRR :View category listing ;:Field category_name i <:Field description K =:Field picture 7 >View customer listing ?>Field company_name b @>Field contact_name Q A>Field phone 2 BView supplier listing CBField company_name I DBField contact_name 0 EBField phone / FView sales detail ( GFField exp_1 ' HFField order_date & IFField sum_unit_price $ JIndex order_id KView order history line items : LIndex cust_ord L M&Index category_n F N Field group_id N O Field description O P Field startup_action P Q Index descriptio : RField order_id SField product_id TField unit_price UField quantity VView orders view  WVField order_number  XVField order_date YVField ship_to_name ZVField ship_to_address + [VField ship_to_city \VField ship_to_region - ]VField ship_to_postal_code / ^VField ship_to_country 1 _VField discount `VField freight 3 aVField unit_price 5 bVField quantity  cVField company_name_a  dVField address eVField city fVField region gVField postal_code  hVField country iVField company_name_b  jVField product_name kView employee listing lkField title mkField last_name s nkField first_name h okField extension X pkField notes ; q Field customer_id r Field company_name s Field contact_name < t Field contact_title = u Field address > v Field city ? w Field region @ x Field postal_code A y Field country B z Field phone C { Field fax D | Field max_order_amt ? } Field min_order_amt ~ Field discount G  Field sales_region H Field product_id l Field supplier_id q Field category_id r Field product_name Field english_name t Field quantity_in_unit u Field unit_price v Field unit_cost w Field units_in_stock x Field units_on_order y Field reorder_level z Field discontinued { Field shipper_id e Field company_name Field supplier_id T Field company_name Field contact_name Y Field contact_title Z Field address [ Field city \ Field region ] Field postal_code ^ Field country _ Field phone ` Field fax a &Field category_id &Field category_name &Field description &Field picture_file &Field picture "Field employee_id "Field last_name "Field first_name "Field title "Field birth_date "Field hire_date "Field address "Field city "Field region "Field postal_code "Field country "Field home_phone "Field extension "Field group_id "Field sales_region "Field password "Field photo_file "Field notes "Field photo Database StoredProceduresDependencies View order history ' Field order_id Field customer_id Field shipper_id Field order_number Field order_date Field ship_to_name Field ship_to_address Field ship_to_city Field ship_to_region Field ship_to_postal_code Field ship_to_country Field discount Field freight Field paid E Field deliver_by Field notes Field employee_id View ordertotal  View top25cust 2 KField exp_1 * KField product_name ; KField quantity 7 KField unit_price 9 KField extension = KField product_id B Field customer_id ) Field ordertotal ( Field customer_id & Field company_name % Field country $ Field custtotal # Field order_id Field order_date Field deliver_by Field ord_total Field paid